Forum Discussion
Date Variable wrong format
Hi, I want to create a variable in my DAX formula. Var = maxdate= max(DateTable[Date])-7, this should gives me the maxdate from selected slicer in YYYY-MM-DD format but it gives me a numeric val...
I think I have to pologize, I work in Power Pivot, normally Power BI. And I now realize that these measure doesent act the same. All answers is probably correct. But in Power Pivot it fails when I put -7 in the formula.
If I skip -7 it shows me a results, but I can not find a way to offset my enddate.