Forum Discussion

sthokchom's avatar
sthokchom
Frequent Visitor
2 years ago

Help needed to DAX logic

Hi Community, Could you please help me solving the below use case. I have calender table consists of year and month. I have both year and month values as a 2 different slicer on report. Now I want ...
sthokchom's avatar
sthokchom
Frequent Visitor
2 years ago

Hi 123abc ,

Thanks for helping me out. However, I am looking for something that will be solved this using one calcualted column.

Below is detialed use case:

Slicer 1 : Year (Values:2024, 2023, 2022 etc)

Slicer 2 : Month (Values : Jan - Dec)

 

Now, what I am trying to acheive is when I select 2024 in the Slicer 1, I should only see months in Slicer 2 that have been passed incluing the logic that I don't want to see previous month, until 21st of each month. Since we are in Jan , so nothing should come up for 2024. Once Feb 21st 2024 arrives, I need to see Jan value in Slicer 2 and it will continue for the rest of months. When I select any previous year in Slicer 1, I should all the of the months.

Hope this makes sense.

 

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi sthokchom,

Current power bi does not support to create dynamic calculated column/table based on filter effects. They weren't hosted on the same level and you can't use the child level to effect the parent level.

Notice: the data level of power bi(from parent to child level)

Database(external) -> query table(query, custom function, query parameters) -> data model table(table, calculate column/table) -> data view with virtual tables(measure, visual, filter, slicer)

Regards,

Xiaoxin Sheng

  • sthokchom's avatar
    sthokchom
    Frequent Visitor
    2 years ago

    Hi 123abc ,

    Thanks for your valuavle input. But none of those are working. When I select 2024 in Slicer 1, nothing happnes in slicer 2. All the months still get displayed.