Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I have a report that calculates the YoY revenue rate, using direct query mode.
The following measures are similar to this:
gbprevenue = CALCULATE(SUM('revenue'[gbp]), 'revenue'[type] <> "Lost")
Solved! Go to Solution.
Most of the time intelligence function works best with the continuous date. Create a date table using the calendar function of Powerbi.
https://docs.microsoft.com/en-us/dax/calendar-function-dax
https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions
Join that with you date nad then try.
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.
Most of the time intelligence function works best with the continuous date. Create a date table using the calendar function of Powerbi.
https://docs.microsoft.com/en-us/dax/calendar-function-dax
https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions
Join that with you date nad then try.
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.
Sorry for the late response.
Using a calendar function with a relationship fixed the issue.
Thanks
User | Count |
---|---|
128 | |
108 | |
100 | |
64 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |