Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi @ALEX2011ALfer_ ,
Did you mean which value is unique in the last 6 months?
Create measure via the following code and put it in filter pane on this visual and set it show items is 1, then you will see the unique value in the table.
Measure =
VAR _currentdate =
TODAY ()
VAR _start =
DATE ( YEAR ( _currentdate ), MONTH ( _currentdate ), 1 )
VAR _range =
DATESINPERIOD ( 'Table'[Date], _start, -6, MONTH )
VAR _last_6_months_value =
CALCULATETABLE ( 'Table', _range )
RETURN
COUNTROWS ( _last_6_months_value )
Or you want to show the values which is not appear during last 6 months.
Value of last 6 months not the same =
VAR _currentdate =
TODAY ()
VAR _start =
DATE ( YEAR ( _currentdate ), MONTH ( _currentdate ), 1 )
VAR _range =
DATESINPERIOD ( 'Table'[Date], _start, -6, MONTH )
VAR _last_6_months_value =
CALCULATETABLE ( VALUES ( 'Table'[values] ), _range )
VAR _current_month =
CALCULATETABLE ( VALUES ( 'Table'[values] ), DATESMTD ( 'Table'[Date] ) )
VAR _new_value =
EXCEPT ( _current_month, _last_6_months_value )
RETURN
CONCATENATEX ( _new_value, [values], " " )
Pbix file in the end you can refer.
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @ALEX2011ALfer_ ,
Did you mean which value is unique in the last 6 months?
Create measure via the following code and put it in filter pane on this visual and set it show items is 1, then you will see the unique value in the table.
Measure =
VAR _currentdate =
TODAY ()
VAR _start =
DATE ( YEAR ( _currentdate ), MONTH ( _currentdate ), 1 )
VAR _range =
DATESINPERIOD ( 'Table'[Date], _start, -6, MONTH )
VAR _last_6_months_value =
CALCULATETABLE ( 'Table', _range )
RETURN
COUNTROWS ( _last_6_months_value )
Or you want to show the values which is not appear during last 6 months.
Value of last 6 months not the same =
VAR _currentdate =
TODAY ()
VAR _start =
DATE ( YEAR ( _currentdate ), MONTH ( _currentdate ), 1 )
VAR _range =
DATESINPERIOD ( 'Table'[Date], _start, -6, MONTH )
VAR _last_6_months_value =
CALCULATETABLE ( VALUES ( 'Table'[values] ), _range )
VAR _current_month =
CALCULATETABLE ( VALUES ( 'Table'[values] ), DATESMTD ( 'Table'[Date] ) )
VAR _new_value =
EXCEPT ( _current_month, _last_6_months_value )
RETURN
CONCATENATEX ( _new_value, [values], " " )
Pbix file in the end you can refer.
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@ALEX2011ALfer_ You may find this helpful - https://community.powerbi.com/t5/Community-Blog/To-bleep-With-Time-Intelligence/ba-p/1260000
Also, see if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.
https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TIT...
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
31 | |
16 | |
14 | |
14 | |
9 |