Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Expert
How do you get around the following issue when writing cumulative measures in Direct Query Mode....
See image
Here are the Measures in Question - Measures
Solved! Go to Solution.
@Anonymous , do some of these dates have timestamp, if that is not needed in the visual create date without timestamp and use those in meausre.Or Join Dates with the date of date table and try using date of date table in place of these dates in cumulative logic
@Anonymous , do some of these dates have timestamp, if that is not needed in the visual create date without timestamp and use those in meausre.Or Join Dates with the date of date table and try using date of date table in place of these dates in cumulative logic
Hi Amit Checking.....And how would the dates from the date table work?
User | Count |
---|---|
96 | |
85 | |
77 | |
66 | |
63 |
User | Count |
---|---|
110 | |
96 | |
96 | |
67 | |
59 |