Forum Discussion

Polygon's avatar
Polygon
Helper I
6 years ago

DSO DAX Calculation - Countback Method

Your assistance is greatly needed please.  I'm looking for the DAX calculation to calculate DSO usisng the Countback Method. Calculation of DSO in Dec:                           Aug     Sep     Oc...
Need Help
Ymir's avatar
Ymir
Regular Visitor
4 years ago

Hey this is interesting.

Would you be so very kind to attach the pbix file with the above solution (if you have it).

Thank you so much

bcteh's avatar
bcteh
Frequent Visitor
4 years ago

Here you go..... the snippet of the file.

PBIX file is shared in one drive below.
DSO Countback.pbix 

 

  • Ymir's avatar
    Ymir
    Regular Visitor
    4 years ago

    Thank you so much 🙂 This saved me a lot of work.

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      I am working on DSO caculations and my DSO values should dynamically calculate according to different geograpical aggregations.

      Can you please share how you have achived it.

    • kunwar2's avatar
      kunwar2
      New Member
      2 years ago

      I am not able to download the PBIX. Can you please share an updated link.

  • kunwar2's avatar
    kunwar2
    New Member
    2 years ago

    I am not able to download the PBIX. Can you please share an updated link.