Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Cumulative measure based on TREATAS

Hi All,   I want to display cumulative line chart based on the Revenue. However, my issue is that the x-axis in the line chart comes from another table [Para_Period] which has no relationship with ...
Need Help
Show and Tell
  • Jihwan_Kim's avatar
    Jihwan_Kim
    5 years ago

    Hi, Anonymous 

    Thank you for sharing your sample pbix file.

    Please correct me if I wrongly understood your data model, but I could not find a date-type column in ParaPeriod table and fact table. So I created ones based on the key column. I could not use key column in the measure, because it is text type, not the date-type.

     

    Please check the below link, and all measures I created are inside the sample pbix file.

     

    https://www.dropbox.com/s/94dnih8v6s7kihl/Test%20Cumulative.pbix?dl=0 

     

     

    Hi, My name is Jihwan Kim.

     

    If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

     

    Linkedin: linkedin.com/in/jihwankim1975/

    Twitter: twitter.com/Jihwan_JHKIM

     

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Jihwan_Kim , I have updated the [Actl_Rev_Range] measure in the PBIX. Currently the measure you have created doesn't factor in weeks that doesn't belong in the quarter selected in slicer, for example, 02-Apr (Wk40) should be showing 11 instead of 12. 

 

Is it possible to make use of [Actl_Rev_Final (format)] in your logic as I'm using this measure in my dashboard. Basically this measure will only display weeks that belong to the fiscal quarter and assign the correct value accordingly.

 

https://www.dropbox.com/s/ojof7opjuf92itd/Test%20Cumulative.pbix?dl=0 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Jihwan_Kim , please ignore my previous reply. I do realise I can just make use of the measure you have created. Thank you so much for the help!

 

Regards,

BK