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.
I have 3 columns Activity period, fiscal period and gross_profit having monthly data .I have activity period on slicer. Now I want to show gross profit of next two fiscal period months. I am not getting how can I approach it I have tried using dateadd function but not getting expected result also tried using calculate function I am still not getting what is expected, please help me I am new to Power BI community
(note-Gross profit is a measure)
On selecting slicer (Activity period= may 2021)
input:
Activity period | Fiscal period | Gross profit |
may 2021 | april 2021 | 333 |
may 2021 | may 2021 | 4303 |
may 2021 | june 2021 | 3340 |
may 2021 | july 2021 | -1112 |
may 2021 | august 2021 | 230 |
output:
Activity period | Fiscal period | Gross profit |
may 2021 | april 2021 | |
may 2021 | may 2021 | |
may 2021 | june 2021 | 3340 |
may 2021 | july 2021 | -1112 |
may 2021 | august 2021 |
Solved! Go to Solution.
Hi, @abhijit_vetal
You can try the following steps:
1.create a saperate calculated table
Slicer = DISTINCT('Table'[Fiscal period])
2.add a new measure to replace the value of measure[M_Gross profit]
M_result =
IF (
DATEDIFF (
MAX ( Slicer[Fiscal period] ),
MAX ( 'Table'[Fiscal period] ),
MONTH
)
IN { 1, 2 },
[M_Gross profit],
BLANK ()
)
Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @abhijit_vetal
You can try the following steps:
1.create a saperate calculated table
Slicer = DISTINCT('Table'[Fiscal period])
2.add a new measure to replace the value of measure[M_Gross profit]
M_result =
IF (
DATEDIFF (
MAX ( Slicer[Fiscal period] ),
MAX ( 'Table'[Fiscal period] ),
MONTH
)
IN { 1, 2 },
[M_Gross profit],
BLANK ()
)
Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you so much for Solving my problem Really apreciated. Keep doing great work for community
User | Count |
---|---|
88 | |
72 | |
69 | |
65 | |
57 |
User | Count |
---|---|
95 | |
93 | |
91 | |
75 | |
69 |