Forum Discussion
To Stop Measure Calculation for Future Months
I actually found a solution. I created a Date table and joined to my Fact Table. I use the date from the Date table in the visual on the xaxis and use the logic above when calculating uptime.
I created a flag column in the date table to check if the date is before today (since I won't have data past today from my fact table). I use the flag in the filter panel.
Unfortunately, that didn't work. I ended up just creating a Date table and joining the two tables. When using the date field from the Date table on the x-axis I'm able to show 100% uptime for months where there is no data.
The issue as to why data was appearing for future months was when creating the relationship initially between my date table and data table, the date mapping was wonky. So I had to redo the relationship and ensure that both date fields being joined on were of the date datatype.
Hi Anonymous ,
In order to find the cause of problem and give you a solution shortly, could you please share a simplified pbix file with me? You can refer the following link to upload the file to the community. Thank you.
How to upload PBI in Community
Best Regards
I actually found a solution. I created a Date table and joined to my Fact Table. I use the date from the Date table in the visual on the xaxis and use the logic above when calculating uptime.
I created a flag column in the date table to check if the date is before today (since I won't have data past today from my fact table). I use the flag in the filter panel.