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,
I am facing a simple problem (probably) which I am unable to resolve.
Problem is while computing the MTD values totals are matching. Below is the screen shot.
Formula : MTD = TOTALMTD(SUM(COMM_YTD[CALC_RET_COMM]),DATESMTD('Calendar'[DateKey].[Date]))
The same method I have used earlier which is working perfectly this time I don't know what happened.
Please help me on this.
My only comment is that using both TOTALMTD and DATESMTD is redundant. Should either do:
MTD = TOTALMTD(SUM(COMM_YTD[CALC_RET_COMM]), Calendar[Date] )
or
MTD = CALCULATE( SUM(COMM_YTD[CALC_RET_COMM]), DATESMTD (Calendar[Date] ) )
Hi @mattbrice
This PBIX file has two versions of the formula that work.
Download and have a play to see if it helps.
Cheers,
Hi,
I am facing a simple problem (probably) which I am unable to resolve.
Problem is while computing the MTD values totals are matching. Below is the screen shot.
Formula : MTD = TOTALMTD(SUM(COMM_YTD[CALC_RET_COMM]),DATESMTD('Calendar'[DateKey].[Date]))
The same method I have used earlier which is working perfectly this time I don't know what happened.
Please help me on this.
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 |
---|---|
112 | |
99 | |
73 | |
72 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |