DAX Measure to Count Number of days in a Period based on Different Period Conditions

[Anonymous]

Hi All,

I have a date when a file was created, but there is a condition based on another column called group that:

if Table[group] = Critical, and the date created>30 days then days should start counting

if Table[group] = High, and the date created>30  days then days should start counting

if Table[group] = Medium, and the date created>90 days then days should start counting

if Table[group] = low, and the date created>30 days then days should start counting

Attached is a screenshot of sample data. Thanks in advance.

[Anonymous]

Hi @Anonymous 

So in your sample , how many tables are there in total ? How to count the days start ? Can you provide a sample with detailed data ? If possible, provide your calculation logic and the result you want .

Best Regards,
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
 

[Anonymous]

Hi @Anonymous 

For now I am combining the tables to become one. I attached a screeshot of my calculation and logic.

If here is a possibility of  also giving me an instance when the table is separate as well will also go along way. Thanks.