Below is my request to figure out the MonthwiseTotal column using DAX measure. I have tried using TotalMTD function but it is working. Can any one pls help on this.
Solved! Go to Solution.
Below is the code for the output Esha.. We need to filter based on the User right. it works fine.
Thank you for your help as well.
Please see this example below, i have removed the user C an D from the second table but still it is summing all the users value. I need to sum only the selected user values. Please help me with this example.
It is calculating the total for all the users. if i added or removed some of the user, that time also it is showing the same total sum value. I need total for only selected users.
this article Time patterns – DAX Patterns contains almost everything you need to know to create time/date related calculations.
It's necessary that you create a dedicated calendar table and then create a measure that cumulates the values from all the data less and equal to the selected date.
Hopefully, this helps to tackle your challenge.
Click here to learn more about the August 2022 updates!
Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.