Forum Discussion
Nimai123
Post Patron
Post PatronExcel to DAX
I have a formula in excel which is calculating the percentage only if it has data for above 4 qtr How can I convert this in a DAX expression using this logic of the formula Reference image 1 ...
Mariusz
Community Champion
Community ChampionHi Nimai123
You can use DATESINPERIOD
https://docs.microsoft.com/en-us/dax/datesinperiod-function-dax
but you will need to adjust your model, add a date field to your table and Date dimension
https://www.youtube.com/watch?v=Pzn2B4laK9A
Best Regards,
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
LinkedIn
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.