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 weird problem where the TOTALMTD calc is not working as there are records in the table with a Date value in the future (ie beyond today). So it seems to get confused when presenting the output value.
To work around this I filter these records out using the Date field on a Page level filter and everything works fine. I'm now trying to replicate this in the Measure with DAX so it can be dynamic (ie look at data before tomorrow but include today) but I'm not getting the same result.
Here is the filter I used as the test
shouldn't the following do the trick?
Total Billing MTD = TOTALMTD ( SUM(BillingFact[Billed]), BillingFact[Date (daily)], FILTER(BillingFact, BillingFact[Date] < TODAY() +1) )
Hi @Anonymous,
Please try this formula:
Total Billing MTD = TOTALMTD ( CALCULATE ( SUM ( BillingFact[Billed] ), FILTER ( BillingFact, BillingFact[Daily Date] < TODAY () + 1 ) ), BillingFact[Daily Date] )
Regards,
Yuliana Gu
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 |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |