Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
104 | |
79 | |
68 | |
61 |
User | Count |
---|---|
144 | |
104 | |
103 | |
82 | |
70 |