User Profile
Stabben23
Helper I
Joined 7 years ago
User Widgets
Contributions
Total sum with different granularity
Hi, I want to Summerize a total value for Goal. Goal is a one time value on my machines. The model is connected With Machine (Maskin) field to Transaction table, no other table is connected. Value, date, machine field is from Transaction table, Goal from my Goal table. The sum in this case should be 520.8 instead of 130.20. I want this as a Dax measure.Re: Flag in Calendar
Thanks for answer, if I use your Week Type = var _st = today() +-1*WEEKDAY(today() ,2)+1 var _end = today() + 7-1*WEEKDAY(today(),2) return Switch( True(), [Date] >= _st && [Date] <= _end ,0 , [Date] >= _st-7 && [Date] <= _end -7,1 ) and change place on 1 and 0 I get what I want for now as you see in my table. But Tomorrow it should change so All 1 gets 0 and All 0 get 1 because its Thuesday, will that work dynamic?Re: Date Variable wrong format
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.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 value for the date. So when I try to filter DateTable <= maxdate it doesent filter. If I define the Variable like Date(2021-09-01) everything works fine.
