If with dates from excel in Power BI

[Anonymous]

Hello All.

We are creating a report and again need your help. Don't know how to convert formula from excel to power bi.

in excel it should look like IF YTD = month 6 , YTD (6), YTD – YTD

Only this idea appeared for POwer BI, but it, of course, doesn't work:

IF (lastday( Dates[Dates]) < MONTS () , CALCULATE ( SUM() – SUM(previous month )

Thanks a lot for your help 🙂

[dax]

Hi Natalia_ 

I am not clear about your requirement, if possible could you please inform me more detailed information(such as your expected output and your sample data)? Then I will help you more correctly.

Please do mask sensitive data before uploading.

Thanks for your understanding and support.
Best Regards,
Zoe Zhi

[sturlaws]

Hi,

could you create an excel sample file with some data and the formula? Upload it to onedrive/dropbox/other and share the link

br,

S