Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi everyone!
I need to create custom date periods based on the user input. I personally was able to get to the point where I could manually generate Period Start and Period End dates within my Calendar table and then combine them in another column.
So right now in my calendar table I have a Date column and the following DAX callculated columns
16-15 Period Start
16-15 Period Start =
VAR pStart = DATE(YEAR('Table'[Date]),MONTH('Table'[Date]) - 1, 16)
VAR pStartSwitch = DATE(YEAR('Table'[Date]), MONTH('Table'[Date]), 16)
RETURN
IF(
'Table'[Date] > pStart && 'Table'[Date] < pStartSwitch,
pStart,
pStartSwitch
)
16-15 Period End
16-15 Period End =
VAR pStart = DATE(YEAR('Table'[Date]),MONTH('Table'[Date]) + 1, 15)
VAR pStartSwitch = DATE(YEAR('Table'[Date]), MONTH('Table'[Date]), 15)
RETURN
IF(
'Table'[Date] < pStart && 'Table'[Date] > pStartSwitch,
pStart,
pStartSwitch
)
and 16-15 Period
16-15 Period = FORMAT('Table'[16-15 Period Start],"dd/mm/yyyy") & "-" & FORMAT('Table'[16-15 Period End],"dd/mm/yyyy")
Basically I want to be able to generate such periods based on the user input start date. I can easliy do it manually and create these columns for every single period and make a user choose between all these custom generated periods, however it seems impractical and I'm sure there should be a better option out there. I was thinking about somehow connecting Period Start and Period End to the What If parameter however I have no clue on how to impement it within my current calendar table. Any help is appreciated. Thanks in advance!
Solved! Go to Solution.
@Jazzlike , No slicer parameter can not be used in table columns and table calculations.
You can only create measures using slicer parameters
@Jazzlike , No slicer parameter can not be used in table columns and table calculations.
You can only create measures using slicer parameters
User | Count |
---|---|
107 | |
89 | |
81 | |
76 | |
73 |
User | Count |
---|---|
112 | |
104 | |
96 | |
74 | |
66 |