Forum Discussion
Quarter over Quarter calculation - Display Quarters missing
Hi,
Share the download link of the PBI file.
Hi,
I am not sure how your semantic model looks like, but I tried to create a sample pbix file like below.
Please check the below picture and the attached pbix file.
One of ways is to create a separate calendar table and create a relationship with the fact table.
And, I tried to use OFFSET DAX function in the measure.
OFFSET function (DAX) - DAX | Microsoft Learn
Lost Decline customers count: =
CALCULATE (
SUM ( data[customers_count] ),
'status'[bat_status] IN { "lost", "decline" }
)prev: =
CALCULATE (
[Lost Decline customers count:],
OFFSET (
-1,
ALL ( 'calendar'[Rolling_Q], 'calendar'[SEG_MONTH] ),
ORDERBY ( 'calendar'[SEG_MONTH], ASC )
)
)QoQ: =
DIVIDE([Lost Decline customers count:] - [prev:], [prev:])
Thank you Jihwan_Kim
My table does not contain a date field to display the months included in ROLLING_Q; the only field related to a date is SEG_MONTH. I previously created a table to assign those two and create a relationship so that I could use ROLLING_Q, but it did not work.
I have shared the file; could you take a look at it?. Here is the link:
PBI_Rolling_Q