Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Calculation between date periods

Hi all,   I am really struggling here and could do with some help!!   I am creating a Patching dashboard and as such, i want to show a difference between two date periods   I am showing the cou...
Need Help
Tips and Tricks
  • v-frfei-msft's avatar
    v-frfei-msft
    7 years ago

    Hi Anonymous,

     

    I made one sample for your reference.

     

    1. Create a date table and create relationship with the fact table.

     

    Table = CALENDAR(MIN(Table1[date]),MAX('Table1'[date]))

    2. Create a measure as below.

     

    count = CALCULATE(COUNTROWS('Table1'),ALLSELECTED('Table'))

     

    For more details, please check the pbix as attached.

    Regards,

    Frank

v-frfei-msft's avatar
v-frfei-msft
Community Support
7 years ago

Hi Anonymous,

 

I made one sample for your reference.

 

1. Create a date table and create relationship with the fact table.

 

Table = CALENDAR(MIN(Table1[date]),MAX('Table1'[date]))

2. Create a measure as below.

 

count = CALCULATE(COUNTROWS('Table1'),ALLSELECTED('Table'))

 

For more details, please check the pbix as attached.

Regards,

Frank

v-frfei-msft's avatar
v-frfei-msft
Community Support
7 years ago

Hi Anonymous,

 

Does that make sense? If so, kindly mark my answer as a solution to close the case.


Regards,
Frank