Forum Discussion
Resolver ICumulative Values Not Showing Correctly On Date Axis
Hi sperry ,
Please try to update the formula of measure [Total Cumulative Boosters Required Maori] as below and check whether it can get your expected result. You can find the details in the attachment.
Note: The part with red font is updated one...
Total Cumulative Boosters Required Maori =IF (ISBLANK ( [Total Cumulative Eligible Booster Māori] )|| ISBLANK ( [Total Cumulative Boosters Administered DHB Residence Māori] ),BLANK (),( 'COVID-19 Vaccinations DHB of Residence'[Total Cumulative Eligible Booster Māori] - 'COVID-19 Vaccinations DHB of Residence'[Total Cumulative Boosters Administered DHB Residence Māori] ))Best Regards
Perfect - works a treat..thanks for that
Resolver IYou are absolutely right - I use the data for several reasons so some rows are validly blank for the "Eligible Booster Date" fields. Not sure how this helps me. If I filter out the blank dates then incorrect values are shown in the column chart visual
Hi sperry ,
Please try to update the formula of measure [Total Cumulative Boosters Required Maori] as below and check whether it can get your expected result. You can find the details in the attachment.
Note: The part with red font is updated one...
|
Total Cumulative Boosters Required Maori =
IF (
ISBLANK ( [Total Cumulative Eligible Booster Māori] )
|| ISBLANK ( [Total Cumulative Boosters Administered DHB Residence Māori] ),
BLANK (),
( 'COVID-19 Vaccinations DHB of Residence'[Total Cumulative Eligible Booster Māori] - 'COVID-19 Vaccinations DHB of Residence'[Total Cumulative Boosters Administered DHB Residence Māori] )
)
|
Best Regards
- sperry
Perfect - works a treat..thanks for that