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 working measurethat shows the current MTD revenue that looks like this:
Solved! Go to Solution.
How about continue the pattern you started for the Day level too:
MTD Revenue= CALCULATE(SUM('Sales'[Sales Amount]), 'Date'[Month]=MONTH(TODAY()), 'Date'[Year]=YEAR(TODAY()), 'Date'[Day] <> DAY(TODAY())
If this solution works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
@msimmonsmcse , Try with time intelligence and date table
MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD('Date'[Date]), 'Date'[Date] <Today())
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :
https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions
https://www.archerpoint.com/blog/Posts/creating-date-table-power-bi
https://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/
How about continue the pattern you started for the Day level too:
MTD Revenue= CALCULATE(SUM('Sales'[Sales Amount]), 'Date'[Month]=MONTH(TODAY()), 'Date'[Year]=YEAR(TODAY()), 'Date'[Day] <> DAY(TODAY())
If this solution works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Perfect, 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 |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
58 | |
50 | |
44 | |
19 | |
18 |