Forum Discussion

ChrisPBIUser's avatar
ChrisPBIUser
Icon for Helper III rankHelper III
5 years ago
Solved

Cumulative applications by hour using 2 different date ranges provided by timeline date slicers

Hi, hope someone can help.   I have the following dax measure to cumulative add loan applications by hour which works fine Cummulative Apps = CALCULATE ( SUM ( Loans[Comp. Apps] ), FILTER ( AL...
Need Help
  • ChrisPBIUser's avatar
    ChrisPBIUser
    5 years ago

    Managed to solve the problem myself.

v-lionel-msft's avatar
v-lionel-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi ChrisPBIUser ,

 

Please provide a sample .pbix file.

 

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

ChrisPBIUser's avatar
ChrisPBIUser
Icon for Helper III rankHelper III
5 years ago

Unfortunately due to data protection I cannot provide the actual PBIX file and don't really have the time to redact the data or make up data to provide a sample file, it would just take too long.

 

The schema and DAX statements above should give you plenty to assist or suggest a different approach.