topic Help me to write the Measure calculation in Power BI in DAX Commands and Tips

Help me to write the Measure calculation in Power BI

AFRATH34 — Mon, 15 Jul 2024 05:24:23 GMT

Hi Team,

I hope this email finds you well.

I need assistance with writing a Measure calculation in Power BI that involves two conditions. Although I have mentioned the two conditions correctly in the attached ScreenShot and tried to create the formula based on them, it is not working as expected..

Here are the details:
- I am using a slicer for Date filter, and the dates are available in the "Date_Table" table.
- The measure should calculate the output based on the selected date filter values.

Please refer to the attached ScreenShot for the exact conditions and the expected result. Your help in providing the correct formula for this measure would be greatly appreciated.

Thank you for your support.

Best regards,
Afrath

Re: Help me to write the Measure calculation in Power BI

BeaBF — Mon, 15 Jul 2024 07:16:03 GMT

AFRATH34 can you share the pbix file? or instead paste formulas and data so that we can make copy and paste.

Thx,

BBF

Re: Help me to write the Measure calculation in Power BI

AFRATH34 — Mon, 15 Jul 2024 11:22:12 GMT

Hi BeaBF ,

Could you please explain how I can attach the PBIX file?

Thank you for your assistance.

Best regards,
Afrath

Re: Help me to write the Measure calculation in Power BI

BeaBF — Mon, 15 Jul 2024 12:08:46 GMT

AFRATH34 UpLload the file in drive and then share the link.

BBF

Re: Help me to write the Measure calculation in Power BI

AFRATH34 — Mon, 15 Jul 2024 14:28:50 GMT

Hi BeaBF ,

Please find the link to the file: [https://drive.google.com/drive/folders/1fl52xaMFfa5lRMOzGqfwy_MQdbal3tAu ].

I need your support in creating a measure column. I have not created the measure yet and would appreciate your assistance. The desired output for the "J0D8" Opp ID was mentioned in an earlier screenshot.

Here are the conditions for the measure:

If New Date1 < SelectedMonthEnd and SelectedMonthStart <= New Date1, then the measure should be Upfront Gross Profit * IG Forecast TCGP.
If New Date2 < SelectedMonthEnd and Expiry Date >= SelectedMonthStart, then the measure should be Recurring Gross Profit per Period * IG Forecast TCGP.

Thank you for your support.

Best regards,
Afrath

Re: Help me to write the Measure calculation in Power BI

BeaBF — Tue, 16 Jul 2024 07:18:16 GMT

AFRATH34 Please accept the request to access the drive.

Re: Help me to write the Measure calculation in Power BI

AFRATH34 — Tue, 16 Jul 2024 13:46:12 GMT

Hi BeaBF , I have accept your drive access request.

Sorry for the late response.

Thanks,

Afrath

Re: Help me to write the Measure calculation in Power BI

Anonymous — Fri, 26 Jul 2024 08:21:07 GMT

Hi AFRATH34

Before write a measure, you need to change the format of "New_date1" and "New_date2" to the date type.

Then try the following measure:

MEASURE = IF ( SELECTEDVALUE ( 'All'[New_Date1] ) < SELECTEDVALUE ( Date_Table[SelectedMonthEnd] ) && SELECTEDVALUE ( 'All'[New_Date1] ) > SELECTEDVALUE ( Date_Table[SelectedMonthStart] ), SELECTEDVALUE ( 'All'[Upfront Gross Profit] ) * SELECTEDVALUE ( 'All'[IG Forecast TCGP] ), BLANK () )

Measure2 = IF ( SELECTEDVALUE ( 'All'[New_Date2] ) < SELECTEDVALUE ( Date_Table[SelectedMonthEnd] ) && SELECTEDVALUE ( 'All'[Expiry Date] ) >= SELECTEDVALUE ( Date_Table[SelectedMonthStart] ), SELECTEDVALUE ( 'All'[Recurring Gross Profit per Period] ) * SELECTEDVALUE ( 'All'[IG Forecast TCGP] ), BLANK () )

Result:

Best Regards,

Jayleny

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.