Home Forums Power BI Need help modeling a project – Price Comparison with Conditions Over Period

This topic contains 2 replies, has 1 voice, and was last updated by  tedeichinger 4 months ago.

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • #7973

    tedeichinger
    Participant
    • Started: 1
    • Replies: 2
    • Total: 3

    Working on a project but getting a little lost.  Not sure if I’m not structuring the raw data correctly, or if I’m not thinking the DAX correctly.  I’ve done simular reports comparing data over time with a date table and that worked out but this is a bit diffrent.

    I’ve attached a PowerBI pbix file.  I really simplified the data I’m really working with, but the cals and the idea is still there.  Can you take at what I’m doing, direct me or perhaps add some calcs to the NewShinyCalcs table, add an new tab and repost.  The pbix is only 230Kb.

    Further text details explaining the issues are in the pbix file.

    Thanks!!

     

    Attachments:
    You must be logged in to view attached files.
    #7975

    tedeichinger
    Participant
    • Started: 1
    • Replies: 2
    • Total: 3

    Incase you need the raw data file, see attached.

    Attachments:
    You must be logged in to view attached files.
    #7980

    tedeichinger
    Participant
    • Started: 1
    • Replies: 2
    • Total: 3

    Just thinking out load… since I likely need to filter on the “Comparison Type”, should that be a Calculated Column instead of a Measure?   Just a thought.  My head is starting to hurt.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic.