Delta of Month on Month in tooltip.

[Varshi288]

Hi  All,

I need to find the delta from selected month from previous month. I managed to get the result but it is not working in the tooltip.There are many solutions in the forum but that didnt help me.
Tables : Data , Period 

[Ashish_Mathur · Accepted solution]

Hi,

This approach should work

1. Create a Calendar Table with calculated column formulas for Year, Month name and Month number.  Sort the Month name column by the Month number
2. Create a relationship (Many to One and Single) from the Date column of your Fact table to the Date column of the Calendar Table
3. To your visuals/filters/slicers, drag Year and Month name from the Calendar Table
4. Write these measures

Total = sum(Data[Sales])

Total in PM = calculate([Total],previousmonth(calendar[date]))

Hope this helps.

[Ashish_Mathur · Accepted solution]

Hi,

This approach should work

1. Create a Calendar Table with calculated column formulas for Year, Month name and Month number.  Sort the Month name column by the Month number
2. Create a relationship (Many to One and Single) from the Date column of your Fact table to the Date column of the Calendar Table
3. To your visuals/filters/slicers, drag Year and Month name from the Calendar Table
4. Write these measures

Total = sum(Data[Sales])

Total in PM = calculate([Total],previousmonth(calendar[date]))

Hope this helps.

[Varshi288 · Accepted solution]

Hi  All ,

 Thankyou all for your quick response. I used both  PREVIOUSMONTH and DATEADD to get last month sales both are right. And this is working in matrix visual. But in the bar chart Period field was not recagnised as a date column  (2024_6). After changing to proper date format it worked.

Thanks once again.

[Ashish_Mathur]

You are welcome.

[mickey64]

Step 0: I use these data below.

Step 1: I make a calendar table and add a relationship.

    Calendar = CALENDARAUTO()

Step 2: I make a measure and make a matrix.

M_PreYMth TP$ = CALCULATE(SUM('DATA'[CurMth TP$]),PREVIOUSMONTH('Calendar'[Date]))

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...