topic Re: DAX Help in DAX Commands and Tips

DAX Help

pmadam — Thu, 04 Nov 2021 05:25:28 GMT

Hi Team,

I have a total measure MaxYTDDays which calculates total days in year. But i am trying to create dynamic measure so that it gives total days of selected months only from Year Month column

Year-Month = CONCATENATE(CA[PC Year], CONCATENATE( "-", CA[PC Month]))

My current measure.

MaxYTDDays = Max('VQR NDC'[YTDDays])

And YTD days is calculated from below measure as we do not have unique total days in month column

YTDDays = lookupvalue('Planning Calendar'[Month Days],'Planning Calendar'[Year-Month], Max('VQR NDC'[Year-Month]))

Please help!

Thanks,

Prathy

Re: DAX Help

BeaBF — Thu, 04 Nov 2021 08:56:49 GMT

pmadam Hi!

Could you paste the data on which to calculate the measure and the expected result?

Thx,

Re: DAX Help

AlexisOlson — Thu, 04 Nov 2021 15:13:11 GMT

If you're using a calendar table date dimension properly, then you make the selection on that table and count the rows selected (1 for each day).

I can't tell how things are set up in your particular situation well enough to advise something else.