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 🙂

[v-xuding-msft]

Hi @Anonymous ,

Could you please share some sample data and the expected output? It is helpful for us to understand your requirement and solve it as soon as possible.

Please see this post regarding How to Get Your Question Answered Quickly: 

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Moreover, you could reference this thread firstly.

https://community.powerbi.com/t5/Desktop/YTD-of-years-until-today/td-p/442182

Best Regards,

Xue Ding

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