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.
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.