Forum Discussion

NJ81858's avatar
NJ81858
Helper IV
3 years ago

Backlogging a Date

Hello,   I am trying to create a measure that will give me every date between the beginning of the year and the selected month, with the intent that the user will only select a certain month and wi...
Need Help
NJ81858's avatar
NJ81858
Helper IV
3 years ago

v-yinliw-msft Ok I am not sure what is going on with my file, but I have everything copied and pasted from your file and it is showing all values as 0 currently. The only differences that I have in my attempt are that my table is called 'Dates' instead of 'Date' and my measure is called 'Backlog Range Test' instead of 'Backlog Range'. I have created a new pbix file and attempted your solution on my own and it worked in my new file, but not in my file that I am currently working on. Can you see anything wrong with my attempt at your solution?

 

v-yinliw-msft's avatar
v-yinliw-msft
Community Support
3 years ago

Hi NJ81858 ,

 

There are something need to check: Please use the column in different table to be a slicer.

And please check the tables have no relationship, if they have, probably you need to create a new data table to be a slicer.

 

 

 

 

Best Regards,

Community Support Team _Yinliw

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

  • NJ81858's avatar
    NJ81858
    Helper IV
    3 years ago

    This is what I have, and the two date tables don't have any relationships between them. The 'Dates' table does have relationships with other tables in my model, because that is my central date table that I am using across my report.