Forum Discussion
DAX to show same value for missing months
My data Category Sub category Date Value Cat1 Subcat1 1-Jan 1 Cat1 Subcat2 1-Jan 1 Cat2 Subcat3 1-Jan 1 Cat2 Subcat4 1-Jan 1 Cat1 Subcat1 1-Feb 2 Cat1 Subcat2...
VahidDM
Super User
Super User
The value column can have values from the range (1 to 5). These are like levels. Level 1 to 5. The Level might increase from 1 to 2 in a month or 2 or even more. Lets say a metric Category 1 and Subcategory1 is Level 1 in Jan. We will get this data. The next time we get the data is when it changes to Level 2. Lets say it happens in March. So I need to show Level 1 in Jan and Feb. And Level 2 from March.
In the output table, I am summarising how many metrics are in level 1 to level 5 in each month.