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.
I have a measure that does a calculate of a sum of revenue in a sales table on filtered ledger accounts.
I use a date table with date, quarter and year. The date has a relationship with the date of sales of the salestable.
Then I created a second measure, that calculate's the first measure on the year in the datetable:
Omzet HJ = CALCULATE(
[Omzet],
FILTER(ALL(Datumtabel), Datumtabel[Jaar] = YEAR(TODAY()))
Solved! Go to Solution.
Hi,
I am not sure if I follow but you want to have the calculation on a monthly basis? Now your ALL removes all the filters from your datetable. Afterwards you specify that the year in you calculation needs to be this year, but you don't define the month filter context back. Try this: ALL(Datumtabel[jaar]). This will only remove the year context. For LY you can use YEAR(TODAY())-1 in the measure. One alternative way to do this is to add month selection to your FILTER e.g. Datumtable[Maand]=MAX(Datumtable[Maand]).
I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!
My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/
Proud to be a Super User!
Hi,
I am not sure if I follow but you want to have the calculation on a monthly basis? Now your ALL removes all the filters from your datetable. Afterwards you specify that the year in you calculation needs to be this year, but you don't define the month filter context back. Try this: ALL(Datumtabel[jaar]). This will only remove the year context. For LY you can use YEAR(TODAY())-1 in the measure. One alternative way to do this is to add month selection to your FILTER e.g. Datumtable[Maand]=MAX(Datumtable[Maand]).
I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!
My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/
Proud to be a Super User!
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 |
---|---|
49 | |
27 | |
20 | |
15 | |
12 |
User | Count |
---|---|
58 | |
50 | |
44 | |
19 | |
18 |