topic Re: Show dax measure only for Jan to Jun in DAX Commands and Tips

Show dax measure only for Jan to Jun

jinivthakkar — Thu, 15 Dec 2022 11:55:18 GMT

Hi All,

I have a dax which is looks something like this and it is working fine

MyMeasure1 = CALCULATE( [Table], ref_Dates[Date] >= DATE(2022,1,1), ref_Dates[Date] <= DATE(2022,6,30) ) MyMeasure2 = CALCULATE( [Table1], ref_Dates[Date] >= DATE(2022,1,1), ref_Dates[Date] <= DATE(2022,6,30) ) MyMeasure3 = MyMeasure1/MyMeasure2

I then use measure 1 and 2 in measure 3 and measure 3 is referred on the visuals and it shows a constant line from Jan to Dec which is as expected and correct but what I want to do is, show measure 3 value only from Jan to Jun and then 0 from Jul to Dec.

I tried adding If condition in measure 3 but it is giving me error.

Please guide/help.

TIA

Re: Show dax measure only for Jan to Jun

goncalogeraldes — Thu, 15 Dec 2022 12:28:45 GMT

Hi jinivthakkar ! You can try the following:

MyMeasure3 = SWITCH ( TRUE (), MONTH ( ref_Dates[Date] ) >= 1 && MONTH ( ref_Dates[Date] ) <= 6, MyMeasure1 / MyMeasure2, 0 )

Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍
Thanks!

You can also check out my LinkedIn!

Best regards,
Gonçalo Geraldes

Re: Show dax measure only for Jan to Jun

jinivthakkar — Thu, 15 Dec 2022 13:25:22 GMT

goncalogeraldes thanks for your reply but I am getting error Cannot find name '[Date]':

I also tried a few other ways but nothing seems to work, basically my tables are not populating in the measure.

TIA

Re: Show dax measure only for Jan to Jun

goncalogeraldes — Thu, 15 Dec 2022 14:13:32 GMT

Hello there jinivthakkar ! Try the following:

MyMeasure3 = SWITCH ( TRUE (), MONTH ( SELECTEDVALUE( ref_Dates[Date] ) ) >= 1 && MONTH ( SELECTEDVALUE( ref_Dates[Date] ) ) <= 6, DIVIDE( MyMeasure1 , MyMeasure2 ), 0 )

For additional help, please @ me in your reply!

You can also check out my LinkedIn!

Best regards,
Gonçalo Geraldes

Re: Show dax measure only for Jan to Jun

jinivthakkar — Thu, 15 Dec 2022 14:21:27 GMT

goncalogeraldes I tried this but this gives me a flat line or value as 0, I am not sure if SELECTEDVALUE will work, end users dont have option to select month value.

I already have a bar and line chart and just need to show existing measure only from Jan to Jun without user interaction.

Re: Show dax measure only for Jan to Jun

goncalogeraldes — Thu, 15 Dec 2022 14:41:07 GMT

Hey there jinivthakkar ! In that case you can go with this:

MyMeasure3 = SWITCH ( TRUE (), MONTH ( MAX( ref_Dates[Date] ) ) >= 1 && MONTH ( MAX( ref_Dates[Date] ) ) <= 6, DIVIDE( MyMeasure1 , MyMeasure2, 0 ), 0 )

For additional help, please @ me in your reply!

You can also check out my LinkedIn!

Best regards,
Gonçalo Geraldes

Re: Show dax measure only for Jan to Jun

jinivthakkar — Thu, 15 Dec 2022 16:06:04 GMT

goncalogeraldes Thanks buddy, cheers !!