I posted this the below link in the Help forum, and believe there is a bug in the DAX Date function in Power BI -- it is returning an error when the Day argument is zero. The Excel version of the function works as expected (with Day=0 returning the last day of the previous month). Entering Month=0 works in Power BI (returning December of the previous year), and negative values for the Day argument also work as expected. My sample DAX formula below works for all days UNLESS it happens to be the 14th day of the month -- behaviour that certainly doesn't seem right.
https://community.powerbi.com/t5/Desktop/DATE-function-with-Day-0/m-p/1294869
Calculated column example:
IsDateWithinLast14Days = if([Date]>=date(year(today()),month(today()),day(today())-14),true(),false())
v-xiaoyan-msft
on:
Power BI Embedded with DirectLake Dataset Error
on:
Unable to create new dataflows Power BI GCC tenant
on:
BUG::SLICER::IDbConnection interface