Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello, the ending date of the chart needs to be the month of the current date. I created a calendar table
Solved! Go to Solution.
Hi @Anonymous
You use the Date Hierarchy.So please try to use below measures:
Measure = IF ( MAX ( 'Table'[Date].[Date] ) <= TODAY (), IF ( ISBLANK ( DISTINCTCOUNT ( fOrder[K_NumberOrder] ) ), 0, DISTINCTCOUNT ( fOrder[K_NumberOrder] ) ) )
Or
Measure 2 = IF ( MAX ( 'Table'[Date].[Date] ) <= TODAY (), CALCULATE ( DISTINCTCOUNT ( fOrder[K_NumberOrder] ) ) + 0 )
Regards,
Cherie
Hi @Anonymous
You use the Date Hierarchy.So please try to use below measures:
Measure = IF ( MAX ( 'Table'[Date].[Date] ) <= TODAY (), IF ( ISBLANK ( DISTINCTCOUNT ( fOrder[K_NumberOrder] ) ), 0, DISTINCTCOUNT ( fOrder[K_NumberOrder] ) ) )
Or
Measure 2 = IF ( MAX ( 'Table'[Date].[Date] ) <= TODAY (), CALCULATE ( DISTINCTCOUNT ( fOrder[K_NumberOrder] ) ) + 0 )
Regards,
Cherie
Can i use the same measure for the quarter?
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |