Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello All,
I have this quarter's column (Image 1) and I am trying to make a new column against them as "Past and Future" so right now it is 2021Q3 anything including 2021Q3 should be future and anything below 2021Q3 should be labeled as past but when the data is pulled next quarter i.e 2021Q4, then 2021Q3 becomes past.
So far I added another conditional column (Image 2 and result in Image 3), but the problem with this is next quarter I will have to edit this conditional column as 2021Q3 will be Past. So I was wondering if there is a way this can be done in a better way using DAX?
Solved! Go to Solution.
If I got your question right, you can try this:
Step 1: get quarter end date, add new column, not measure.
QEnd = IF(RIGHT('Table'[Quarter],2) = "Q1", Date(left('Table'[Quarter],4),03,31), IF(RIGHT('Table'[Quarter],2) = "Q2", Date(left('Table'[Quarter],4),06,30), IF(RIGHT('Table'[Quarter],2) = "Q3", Date(left('Table'[Quarter],4),09,30), IF(RIGHT('Table'[Quarter],2) = "Q4", Date(left('Table'[Quarter],4),12,31)))))
Step 2: add one more column to validate current date.
xPastFuture = IF(TODAY() >= 'Table'[QEnd], "Past", "Future")
Change logic as per your need hope this works for you
If I got your question right, you can try this:
Step 1: get quarter end date, add new column, not measure.
QEnd = IF(RIGHT('Table'[Quarter],2) = "Q1", Date(left('Table'[Quarter],4),03,31), IF(RIGHT('Table'[Quarter],2) = "Q2", Date(left('Table'[Quarter],4),06,30), IF(RIGHT('Table'[Quarter],2) = "Q3", Date(left('Table'[Quarter],4),09,30), IF(RIGHT('Table'[Quarter],2) = "Q4", Date(left('Table'[Quarter],4),12,31)))))
Step 2: add one more column to validate current date.
xPastFuture = IF(TODAY() >= 'Table'[QEnd], "Past", "Future")
Change logic as per your need hope this works for you
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
84 | |
84 | |
65 | |
62 | |
55 |
User | Count |
---|---|
179 | |
108 | |
104 | |
71 | |
70 |