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 |
---|---|
114 | |
100 | |
83 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |