- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Calculate measure from selected value from the slicer
Hello
I have few fact table(Revenue) which have the data for 2022 & 2023 as of now. I am creating a calendar table by below formula from the facts table reveue
VAR _StartDate= FIRSTDATE(ALL('Revenue'[Invoicing Cycle]))
VAR _EndDate = LASTDATE(ALL('Revenue'[Invoicing Cycle]))
RETURN
CALENDAR(_StartDate, _EndDate)
This is the below calculation i have to calculate
(Count of HeadCount numbers for Current period - count of HeadCount for Comparison period) |
I will be having two slicer of current period and other one is comparison table .
When a user select in current period JUN 23 and Comparsion period MAR 22, the measure should calculte the count as per the above formula.
Next year when there will be the data for 2024 in the facts table , current period should be 2024 and the comparison period would be the rest of the year. It is a bit complicated situation. Will i have to create two separate calendar table for current and comparison period or is there any better solution for this issue
How to solve this issue?
All suggestions are welcome
Thanks in advnace
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

I believe this is the solution you are looking for, let me know if this helps.
Compare any week/Year using 2 Slicers as input in PowerBI | MiTutorials - YouTube
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

It worked. thank you😊
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

I believe this is the solution you are looking for, let me know if this helps.
Compare any week/Year using 2 Slicers as input in PowerBI | MiTutorials - YouTube

Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code FABINSIDER for a $400 discount!
Power BI Monthly Update - February 2025
Check out the February 2025 Power BI update to learn about new features.

Subject | Author | Posted | |
---|---|---|---|
09-04-2023 09:46 PM | |||
03-11-2024 11:00 AM | |||
03-01-2024 07:46 AM | |||
06-14-2024 10:04 AM | |||
02-23-2024 07:05 AM |
User | Count |
---|---|
88 | |
74 | |
63 | |
48 | |
38 |
User | Count |
---|---|
118 | |
86 | |
80 | |
58 | |
40 |