Forum Discussion

Reetz's avatar
Reetz
Icon for Helper II rankHelper II
7 years ago
Solved

% change from prior month

 I have a table (tbl_USA_Canada) with 3 columns. Date, Territory and % of Sales. I am trying to display the Territory with the % change of sales from the prior month and can't seem to get this to wor...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    7 years ago

    Hi,

    Assuming the entries in the Date column of tbl_USA_Canada Table are proper date entries, try this

    1. Create a Calendar Table
    2. Enter these calculated column formulas in the Calendar Table - Year = YEAR(Calendar[Date]) and Month = FORMAT(Calendar[Date],"mmmm")
    3. Build a relationship from the Date column of the tbl_USA_Canada Table to the Date column of the Calendar Table
    4. In your visual, drag Year and Month from the Calendar Table
    5. Write these measures - Percent of Sales = SUM(Data[% of slaes]) and Percent of Sales in previous month = CALCULATE([Percent of Sales],PREVIOUSMONTH(Calendar[Date]) and Delta = IFERROR([Percent of Sales]/[Percent of Sales in previous moths]-1,BLANK())

    Hope this helps.

SrikanthDXB's avatar
SrikanthDXB
Regular Visitor
3 years ago

Hi, I need help in month on month rate change dax, how to get the xls or pbix posted here, and or to send to some experts
It would be something like

Month     AC_grp  Area    F_count Currency Listed rate Remarks
01/04/22    38         AAA     1            INR        1,100

01/04/22    72         AAA     1            INR        1,000
01/04/22    73         AAA     1            INR        1,000
01/05/22    38         AAA     1            INR        1,500      Rate change
01/05/22    72         AAA     1            INR        1,600      Rate change
01/05/22    73         AAA     1            INR        1,500      Rate change
01/06/22    38         AAA     1            INR        1,500      
01/06/22    72         AAA     1            INR        1,600      
01/06/22    73         AAA     1            INR        1,500      
Since May'22 rate is different to Apr'22 - I need a remark "Rate change, and rate for Jun'22 is same as May'22, the remark should be NIL
How can this be achieved.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    3 years ago

    Hi,

    Do you want a measure or a calculated column formula?  Also, within a date, will the AC_grp be in ascending order?