Forum Discussion

Werdinkaa's avatar
Werdinkaa
Frequent Visitor
6 years ago

DAX calculate difference between current and previous month - show values for all categories

Hi,  I have a model in Power pivot one with so called Keys which is related to my main data (Category,Key,Date, Value) I have a slicer with months and pivot table which shows Key and calculated val...
v-lid-msft's avatar
v-lid-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi Werdinkaa ,

 

We can try to create a seprate dim table first. (keep no relationship with the main table)

 

CategoryTable = Distinct('Main'[Category])

 

Then replace the measure total as following to meet your requirement:

 

Total =
CALCULATE (
    SUM ( Main[Value] ),
    Main[Category] IN DISTINCT ( CategoryTable[Category] )
)

 

 

If it doesn't meet your requirement, kindly share your sample data and expected result to me if you don't have any Confidential Information. Please upload your files to OneDrive For Business and share the link here.


Best regards,