Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
 View Only
  • 1.  (PBI-Data atchd) Unable to COUNT for Prev month Orders in a card

    Bronze Contributor
    Posted Jan 08, 2022 01:34 AM
    Hi Guys,

    I am stuck at this point.. Attchin pbi and data on xls

    Issue: 1

    Calculate PREV month total orders from Dealers in CARD
    Order will be counted when its yes in order colm


    Issue: 2

    Calculate PREV month total DISTINCT orders from Dealers in CARD
    Order will be counted when its yes in order colm

    Issue:3
    Calculate Growth in orders than prev month in table form


    Thanks in advance

    ------------------------------
    Anubhav Mahule
    Lead consultant
    ------------------------------

    Attachment(s)

    pbix
    BR2.pbix   337 KB 1 version
    xlsx
    Data.xlsx   10 KB 1 version


  • 2.  RE: (PBI-Data atchd) Unable to COUNT for Prev month Orders in a card

    Posted Jan 09, 2022 05:28 AM
      |   view attached

    Hi Anubhav,

    I just joined this platform about an hour ago and saw your query.

    I have worked out the measure to calculate prev month, total count and distinct count.

    Few changes were made to the date table as I added new columns for Year and Mnth Year to enable better filter.

    Please do let me know if you have further queries on this and please visit my website at https://powahour.com/. Linkedin https://www.linkedin.com/in/sam-bolade-68718818b/



    ------------------------------
    G Bolade
    RG2 0FZ
    ------------------------------

    Attachment(s)

    pbix
    BR2.pbix   341 KB 1 version


  • 3.  RE: (PBI-Data atchd) Unable to COUNT for Prev month Orders in a card

    Bronze Contributor
    Posted Jan 12, 2022 11:56 PM
    Thats superb.. Works like charm.. Thanks a lot @Sam Casey Bolade

    Your presence in the forum will add value for sure


    ------------------------------
    Anubhav Mahule
    Lead consultant
    ------------------------------



  • 4.  RE: (PBI-Data atchd) Unable to COUNT for Prev month Orders in a card

    Bronze Contributor
    Posted Jan 14, 2022 12:30 PM
    Edited by Beau A Jan 14, 2022 12:30 PM
      |   view attached

    Use this date table instead.. way better and learn to love the (Currentday), (CurrentMonth), (CurrentYear) columns. 

    So if you want last months total.. you would just calculate

    sum(XXX),filter(dim_date,dim_date[CurrentMonth = -1]))

     which means that only records from last month are taken into account when doing the total



    ------------------------------
    Beau A
    Analyst
    MI
    ------------------------------

    Attachment(s)

    pbix
    Template-DateTable.pbix   158 KB 1 version


  • 5.  RE: (PBI-Data atchd) Unable to COUNT for Prev month Orders in a card

    Bronze Contributor
    Posted Jan 15, 2022 12:57 AM
    Thansk a lot.. This template is awsome

    ------------------------------
    Anubhav Mahule
    Lead consultant
    ------------------------------