Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
Good day beautiful people,
I have a problem how to create a visualization for below tables.
Main:
Helper:
Formulas:
Start Date = 64 + Days Frozen + Posting Start Date
Latest Active Date = IF(End Date = blank, Today(), End Date)
Result:
What I would like to show, is a colum chart where month by month my data will be presented.
If my ID's Start Date is 3/18/2018 and Latest Adctive Date is 6/23/2022, I would like to show this ID in March, April, May and June.
For second example, SD 4/6/2022 and LAD 5/23/2022 I would like to show this in April and May only.
Start Date won't be higher than a Latest Active Date.
I have tried below formula:
For now I was able to present it only for SD's month or LAD's month which is absulutely not correct since in some cases I need multiple months.
(example screens were added from excel, since it was faster for me to create a sample)
Solved! Go to Solution.
Hi, @Magistralis
Please try the following methods.
Table 1 =
SUMMARIZE (
'Table',
'Table'[ID],
"Start Date",
64 + SELECTEDVALUE ( 'Table'[Days Frozen] )
+ SELECTEDVALUE ( 'Table'[Posting Start Date] ),
"Latest Active Date",
IF (
SELECTEDVALUE ( 'Table'[End Date] ) = BLANK (),
TODAY (),
SELECTEDVALUE ( 'Table'[End Date] )
)
)
_Visiu1b =
CALCULATE(COUNT('Table 1'[ID]),
FILTER('Table 1',
[Start Date] <= max('Calendar'[Date]) &&
[Latest Active Date] >= min('Calendar'[Date])
)
)
Is this the result you expect?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @Magistralis
Please try the following methods.
Table 1 =
SUMMARIZE (
'Table',
'Table'[ID],
"Start Date",
64 + SELECTEDVALUE ( 'Table'[Days Frozen] )
+ SELECTEDVALUE ( 'Table'[Posting Start Date] ),
"Latest Active Date",
IF (
SELECTEDVALUE ( 'Table'[End Date] ) = BLANK (),
TODAY (),
SELECTEDVALUE ( 'Table'[End Date] )
)
)
_Visiu1b =
CALCULATE(COUNT('Table 1'[ID]),
FILTER('Table 1',
[Start Date] <= max('Calendar'[Date]) &&
[Latest Active Date] >= min('Calendar'[Date])
)
)
Is this the result you expect?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!