Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
I wrote the below measure to extract my current month forecast figures from a table. The measure returns correct figures for categories B,C,D and a completely different figure for category A alone.
Data Table
Monthly_Toiletries_Forecast = IF([Toiletries Forecast]=0,0, CALCULATE([Toiletries Forecast],FILTER('Date',MONTH('Date'[Date])=MONTH(TODAY())),FILTER('Date',YEAR('Date'[Date]=YEAR(TODAY())))))
Expected results
Current Results
Solved! Go to Solution.
show your measure definition for [Toiletries Forecast]
you can simplify the filter quite a bit too
Monthly_Toiletries_Forecast = IF([Toiletries Forecast]=0,0, CALCULATE([Toiletries Forecast],FORMAT('Date'[Date],"YYYYMM")=FORMAT(TODAY(),"YYYYMM")))
show your measure definition for [Toiletries Forecast]
you can simplify the filter quite a bit too
Monthly_Toiletries_Forecast = IF([Toiletries Forecast]=0,0, CALCULATE([Toiletries Forecast],FORMAT('Date'[Date],"YYYYMM")=FORMAT(TODAY(),"YYYYMM")))
User | Count |
---|---|
12 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
25 | |
19 | |
14 | |
10 | |
7 |