Tabular Model - Dax Summertime/Wintertime -- 2
Budget: $10 – $30 USD
Hello.
DAX Transaction 1: i need a DAX Transaction that can make a statement if it is Summer/Winter Season.
i have now a date column incl. time. the transaction should let me make it possible to change the date and the hour on the date where it should start and stop of summertime and when winter time start.
Example:
Start of Summertime Date 27/03 - Hour 02:00:00
Start of Wintertime Date 30/10 - Hour 02:00:00
DAX Transaction 2:
Start Summer Time: Automatically out of the Date/Time for the actual year
Start Winter Time: Automataclly out of the Date/Time for the actual year
this have to be tested on my site, on my tabular model, the column data that i have to be attached to is with following format "2022-04-01 11:00:00+00:00", it have point at the date and time before the "+".
the result need to show "Summer" & "Winter".
DAX Transaction 1: i need a DAX Transaction that can make a statement if it is Summer/Winter Season.
i have now a date column incl. time. the transaction should let me make it possible to change the date and the hour on the date where it should start and stop of summertime and when winter time start.
Example:
Start of Summertime Date 27/03 - Hour 02:00:00
Start of Wintertime Date 30/10 - Hour 02:00:00
DAX Transaction 2:
Start Summer Time: Automatically out of the Date/Time for the actual year
Start Winter Time: Automataclly out of the Date/Time for the actual year
this have to be tested on my site, on my tabular model, the column data that i have to be attached to is with following format "2022-04-01 11:00:00+00:00", it have point at the date and time before the "+".
the result need to show "Summer" & "Winter".