Forum Discussion
Solved
DAX help with New Measure
Hi all I am hoping the helpful folks here can help me, I am having some trouble with; well almost everything if I’m being honest, but particularly with the DAX part of adding a new measure. I have ...
Mmmm, sadly - no surprise to me either. I suggest you use Power Query to convert your column “6 months” to “days”.
You could split this column into the integer portion and the “period” portion.
do a replace on “months” with 30, year with 365 and day with 1, then multiple the 2 columns to get the service day’s frequency.
The rest should then be easy
Mmmm, sadly - no surprise to me either. I suggest you use Power Query to convert your column “6 months” to “days”.
You could split this column into the integer portion and the “period” portion.
do a replace on “months” with 30, year with 365 and day with 1, then multiple the 2 columns to get the service day’s frequency.
The rest should then be easy
Thanks Matt
I will give it a try.
Cheers.
