Forum Discussion

H3nning's avatar
H3nning
Icon for Helper V rankHelper V
3 years ago

Previous Period as single Value

Hi,   Im experimenting with SCD2 data and I have a problem with a time intelligence related calculation. To keep it simple Id rather not explain the whole complexity of the context.   I have a ta...
Need Help
some_bih's avatar
some_bih
Icon for Community Champion rankCommunity Champion
3 years ago

Hi H3nning as you are on beginning of your project, I suggest to check link about different date calculation in DAX.

Find your scenario, it could be MTD, PMC, PM some other concerning months. Benefit of this solution is that in future you can easly adopt rest of time intelligence calculation which currently you do not need. 

Did I answer correctly? Kudos appreciate / accept solution.

Link: https://www.daxpatterns.com/standard-time-related-calculations/