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 everyone, It´s possible to present the same measure but with different period?
The image shows the sales of the month of November (synchronized with the monthly filter) and in the same table show the annual sales, Is it possible?
Thanks
Solved! Go to Solution.
Hi, I finally made the annual measure
Hi everyone, It´s possible to present the same measure but with different period?
The image shows the sales of the month of November (synchronized with the monthly filter) and in the same table show the annual sales, Is it possible?
Thanks
Could you share more details about relationship between Actual Month and Actual Year? For example, which kind of DAX formula are you using? In addtion, if possible, could you share the original table, not the cahrt? Mark sure mask the sensitive data.
Regards,
Jimmy Tao
Hi ,
Have you tried to use function YTD() and MTD()?
Just using an ALL() on the month column should do the trick. Something like
SUM(Tables1[Sales], ALL(Table1[Month])
Be careful thought with the year. If you show the structure of your data model we could be more precise with the solution
Thanks @AIB well, the structure is very simple, I have a Fact Table and differents Catalogs for the differents dimensions and I have a Catalogo for the Time.
So, If I use a week filter, I have to do an calculated measure ussing that formula ?
Hi, create a Basic Measure like SUM(Sales).
And after that create measures with the desired period. Monthly, Anually, etc
Regards
Victor
Thanks for your help to everyone
I was working with the formulas and I got this for the Monthly Measure, but I couldn´t made work the anual measure.
Could anyone help with the annual measure, please.
Hi, I finally made the annual measure
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 |
---|---|
113 | |
100 | |
78 | |
76 | |
52 |
User | Count |
---|---|
144 | |
109 | |
108 | |
88 | |
61 |