Forum Discussion

martynwb's avatar
martynwb
Regular Visitor
3 years ago

Help with formatting a query, using slicers and dynamic measure updating.

Hi all. A fair amount of experience with BI tooling, but Power BI is new to me. I have 4 tables of hierarchical data, with the lowest level given as a 'maturity' score. In that table there is a 'fo...
Need Help
Show and Tell
Tips and Tricks
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

martynwb , Not very clear. But seem like you need an independent/disconnected date table

 

Need of an Independent Table in Power BI - Exclude: https://youtu.be/lOEW-YUrAbE

 

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

martynwb's avatar
martynwb
Regular Visitor
3 years ago

Thanks Amitchandak! The criticism is fair, I should have been clearer.

Basically, I have a number measure in my table that needs to be 1 after a certain date and 0 before it (the data table has about 1000 dates over the next two years). I need the value to be updated based on a date that the user inputs.

 

So if the user put today as the date (which should be the default), if the date field was tomorrow, the measure would stay as 0. However, if they select a date in two days time, the meaure would be updated to 1.

Thanks!