Forum Discussion

GauravKasar's avatar
GauravKasar
Regular Visitor
1 year ago

PowerBI DAX

I have a user monthly subscription data in Power BI as below:   user_id city subscription_date subscription_plan plan_change_date new_subscription_plan UID0MASMOV Delhi 22-Jan-24 Prem...
Need Help
ArwaAldoud's avatar
ArwaAldoud
Super User
1 year ago

Hi GauravKasar 

Since the relationship in the DateTable is based on subscription_date, selecting a month from the DateTable filters SubscriptionData only by subscription_date, ignoring plan_change_date.

There are multiple ways to solve this issue, but I chose to create calculated columns instead of a measure. This approach helps with debugging and ensures the logic is correctly applied to each row.

I created the following calculated columns: Effective_Month, Effective_Plan and Effective_Year. Then, I calculated revenue based on these columns.

Additionally, I created two measures:
Revenue per Selected Month

Cumulative Revenue (as per your recent request with the expected results)

 

You can find the attached .pbix file for reference.

 

If this response was helpful, please accept it as a solution and give kudos to help other community members.

v-kathullac's avatar
v-kathullac
Community Support
1 year ago

Hi GauravKasar  ,

 

we wanted to kindly follow up to check if the solution provided by the superuser for your issue worked? or Let us know if you need any further assistance?

If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

Regards,

Chaithanya.