Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

DAX

Hi All, I'm trying to solve one User requirement in my power BI I have a two tables  one id Dim_Table and another is Fact_Table In Dim table I have a column News and Content In News I have...
Need Help
Show and Tell
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi  Anonymous ,

Here are the steps you can follow：

1. Create calculated column.

Flag =
var _max=
MAXX(
    FILTER(ALL('Table'),
    'Table'[News]=EARLIER('Table'[News])),[Views])
var _min=
MINX(
    FILTER(ALL('Table'),
    'Table'[News]=EARLIER('Table'[News])),[Views])
return
IF(
    'Table'[Views]=_max,
    "Top View- Globe News for"&""&'Table'[News],
IF(
    [Views]=_min,
    "Low View- Globe News for"&""&'Table'[News]))

2. Result:

 

Best Regards,

Liu Yang

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi,

    I have "News" and "Content" Columns in Dim table and "Views" column in Fact table

    I have given relationship between them using ID column

    Can you please give me the solution as I have mentioned above

    Thanks in advance