Forum Discussion

Mansso's avatar
Mansso
Regular Visitor
6 years ago
Solved

Convert measures to columns

Hi...i have some trouble with PBI.Can anybody help me? I need convert measures to columns..how i can do it with 
Show and Tell
  • Mansso's avatar
    Mansso
    6 years ago

    Ok..i done this..

    I need 1 more help pls)

    I have date column Month.

    I need no make new column.wich means Month Before (is TSQL it is DATEADD (datepart , number , date )

    )

    How i can make this on PBI?

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Mansso，

Due to we are not clear about your table structure and ultimately what visual you want to present your data, could you please provide some sample data and screenshots of the your expected result. It would be better if your PBIX file (exclude sensitive data) could be provided.

 

Best Regards

Rena

Mansso's avatar
Mansso
Regular Visitor
6 years ago

Ok..i done this..

I need 1 more help pls)

I have date column Month.

I need no make new column.wich means Month Before (is TSQL it is DATEADD (datepart , number , date )

)

How i can make this on PBI?

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Mansso ,

    There is also DATEADD function in DAX, please check if you can use this function to return the value you want .

     

    Best Regards

    Rena

  • Mansso's avatar
    Mansso
    Regular Visitor
    6 years ago

    Thx..i'll try it

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Mansso,

    Whether the function DATEADD works well for your scenario?

     

    Best Regards

    Rena

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Mansso ,

    If your problem has been resolved, could you please mark it as Answered? Thank you.

    Best Regards

    Rena