Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 |
---|---|
94 | |
86 | |
78 | |
68 | |
63 |
User | Count |
---|---|
113 | |
99 | |
97 | |
64 | |
59 |