Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
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.
hi @Murali777
You can use this measure
If this post helps, accept it as a solution.
hi @Murali777
You can use this measure
If this post helps, accept it as a solution.
Hi Esha,
Is any input on the below scenario please?
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.
Hi Esha,
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.
The table
the measure ==>
Hi James,
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.
Hey @Murali777
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.
Regards,
Tom
HI
Calculate(sum(value),allexcept(Table[EndofMonth]))
Hi James,
I have tried, but it is not working. if you dont mind pls share the PBIX file.
Thanks.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |