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 Community,
I need your help with the below scenarios,
Today is March 22, 2024, and I want to check,
If today() is between January 1, 2024, and March 29, 2024, then the Flag column should say "Current,"
If today() is between March 30, 2024 and June 28, 2024, the Flag column should say "Not Current."
The flag column should show "Current" from January 1, 2024, to March 29, 2024.
Date |
1/1/2024 |
03/22/2024 |
03/29/2024 |
03/30/2024 |
06/28/2024 |
06/29/2024 |
09/27/2024 |
09/28/2024 |
12/31/2024 |
Expected Result | |
Date | Flag |
1/1/2024 | Current |
03/22/2024 | Current |
03/29/2024 | Current |
03/30/2024 | Not Current |
06/28/2024 | Not Current |
06/29/2024 | Not Current |
09/27/2024 | Not Current |
09/28/2024 | Not Current |
12/31/2024 | Not Current |
Solved! Go to Solution.
@PijushRoy
Our first fiscal Quarter Start from Jan 1,2024 to March 29,2024 and Second Quarter Start from March 30,2024 to June 28,20204 and Third Quarter Start from June 29,2024 to Sep 27,2024 and Fourth Qtr Sep 28,2024 to Dec 31,2024.
If today is 5 the April then It should be in Qtr 2.
pls try this
Hi @tejapowerbi123
Why till March 29, not the end of march 31st?
If today is 5th April, what is the current value?
Please elaborate on the logic clearly
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 |
---|---|
85 | |
83 | |
66 | |
60 | |
57 |
User | Count |
---|---|
183 | |
111 | |
105 | |
77 | |
70 |